package com.rc.evcharger.model.ugs;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class UgsMemberSupeLevelOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UgsMemberSupeLevelOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSuperLevelOrderIdIsNull() {
            addCriterion("super_level_order_id is null");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdIsNotNull() {
            addCriterion("super_level_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdEqualTo(Long value) {
            addCriterion("super_level_order_id =", value, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdNotEqualTo(Long value) {
            addCriterion("super_level_order_id <>", value, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdGreaterThan(Long value) {
            addCriterion("super_level_order_id >", value, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("super_level_order_id >=", value, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdLessThan(Long value) {
            addCriterion("super_level_order_id <", value, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdLessThanOrEqualTo(Long value) {
            addCriterion("super_level_order_id <=", value, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdIn(List<Long> values) {
            addCriterion("super_level_order_id in", values, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdNotIn(List<Long> values) {
            addCriterion("super_level_order_id not in", values, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdBetween(Long value1, Long value2) {
            addCriterion("super_level_order_id between", value1, value2, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelOrderIdNotBetween(Long value1, Long value2) {
            addCriterion("super_level_order_id not between", value1, value2, "superLevelOrderId");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIsNull() {
            addCriterion("tenant_code is null");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIsNotNull() {
            addCriterion("tenant_code is not null");
            return (Criteria) this;
        }

        public Criteria andTenantCodeEqualTo(String value) {
            addCriterion("tenant_code =", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotEqualTo(String value) {
            addCriterion("tenant_code <>", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeGreaterThan(String value) {
            addCriterion("tenant_code >", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeGreaterThanOrEqualTo(String value) {
            addCriterion("tenant_code >=", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLessThan(String value) {
            addCriterion("tenant_code <", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLessThanOrEqualTo(String value) {
            addCriterion("tenant_code <=", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLike(String value) {
            addCriterion("tenant_code like", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotLike(String value) {
            addCriterion("tenant_code not like", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIn(List<String> values) {
            addCriterion("tenant_code in", values, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotIn(List<String> values) {
            addCriterion("tenant_code not in", values, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeBetween(String value1, String value2) {
            addCriterion("tenant_code between", value1, value2, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotBetween(String value1, String value2) {
            addCriterion("tenant_code not between", value1, value2, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("member_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("member_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(Long value) {
            addCriterion("member_id =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(Long value) {
            addCriterion("member_id <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(Long value) {
            addCriterion("member_id >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(Long value) {
            addCriterion("member_id >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(Long value) {
            addCriterion("member_id <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(Long value) {
            addCriterion("member_id <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<Long> values) {
            addCriterion("member_id in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<Long> values) {
            addCriterion("member_id not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(Long value1, Long value2) {
            addCriterion("member_id between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(Long value1, Long value2) {
            addCriterion("member_id not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeIsNull() {
            addCriterion("super_order_type is null");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeIsNotNull() {
            addCriterion("super_order_type is not null");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeEqualTo(String value) {
            addCriterion("super_order_type =", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeNotEqualTo(String value) {
            addCriterion("super_order_type <>", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeGreaterThan(String value) {
            addCriterion("super_order_type >", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("super_order_type >=", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeLessThan(String value) {
            addCriterion("super_order_type <", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("super_order_type <=", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeLike(String value) {
            addCriterion("super_order_type like", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeNotLike(String value) {
            addCriterion("super_order_type not like", value, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeIn(List<String> values) {
            addCriterion("super_order_type in", values, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeNotIn(List<String> values) {
            addCriterion("super_order_type not in", values, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeBetween(String value1, String value2) {
            addCriterion("super_order_type between", value1, value2, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderTypeNotBetween(String value1, String value2) {
            addCriterion("super_order_type not between", value1, value2, "superOrderType");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceIsNull() {
            addCriterion("super_order_source is null");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceIsNotNull() {
            addCriterion("super_order_source is not null");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceEqualTo(String value) {
            addCriterion("super_order_source =", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceNotEqualTo(String value) {
            addCriterion("super_order_source <>", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceGreaterThan(String value) {
            addCriterion("super_order_source >", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceGreaterThanOrEqualTo(String value) {
            addCriterion("super_order_source >=", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceLessThan(String value) {
            addCriterion("super_order_source <", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceLessThanOrEqualTo(String value) {
            addCriterion("super_order_source <=", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceLike(String value) {
            addCriterion("super_order_source like", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceNotLike(String value) {
            addCriterion("super_order_source not like", value, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceIn(List<String> values) {
            addCriterion("super_order_source in", values, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceNotIn(List<String> values) {
            addCriterion("super_order_source not in", values, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceBetween(String value1, String value2) {
            addCriterion("super_order_source between", value1, value2, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderSourceNotBetween(String value1, String value2) {
            addCriterion("super_order_source not between", value1, value2, "superOrderSource");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumIsNull() {
            addCriterion("super_order_num is null");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumIsNotNull() {
            addCriterion("super_order_num is not null");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumEqualTo(String value) {
            addCriterion("super_order_num =", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumNotEqualTo(String value) {
            addCriterion("super_order_num <>", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumGreaterThan(String value) {
            addCriterion("super_order_num >", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumGreaterThanOrEqualTo(String value) {
            addCriterion("super_order_num >=", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumLessThan(String value) {
            addCriterion("super_order_num <", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumLessThanOrEqualTo(String value) {
            addCriterion("super_order_num <=", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumLike(String value) {
            addCriterion("super_order_num like", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumNotLike(String value) {
            addCriterion("super_order_num not like", value, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumIn(List<String> values) {
            addCriterion("super_order_num in", values, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumNotIn(List<String> values) {
            addCriterion("super_order_num not in", values, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumBetween(String value1, String value2) {
            addCriterion("super_order_num between", value1, value2, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andSuperOrderNumNotBetween(String value1, String value2) {
            addCriterion("super_order_num not between", value1, value2, "superOrderNum");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNull() {
            addCriterion("payment_type is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNotNull() {
            addCriterion("payment_type is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeEqualTo(String value) {
            addCriterion("payment_type =", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotEqualTo(String value) {
            addCriterion("payment_type <>", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThan(String value) {
            addCriterion("payment_type >", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThanOrEqualTo(String value) {
            addCriterion("payment_type >=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThan(String value) {
            addCriterion("payment_type <", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThanOrEqualTo(String value) {
            addCriterion("payment_type <=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLike(String value) {
            addCriterion("payment_type like", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotLike(String value) {
            addCriterion("payment_type not like", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIn(List<String> values) {
            addCriterion("payment_type in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotIn(List<String> values) {
            addCriterion("payment_type not in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeBetween(String value1, String value2) {
            addCriterion("payment_type between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotBetween(String value1, String value2) {
            addCriterion("payment_type not between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeIsNull() {
            addCriterion("super_level_type is null");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeIsNotNull() {
            addCriterion("super_level_type is not null");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeEqualTo(String value) {
            addCriterion("super_level_type =", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeNotEqualTo(String value) {
            addCriterion("super_level_type <>", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeGreaterThan(String value) {
            addCriterion("super_level_type >", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeGreaterThanOrEqualTo(String value) {
            addCriterion("super_level_type >=", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeLessThan(String value) {
            addCriterion("super_level_type <", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeLessThanOrEqualTo(String value) {
            addCriterion("super_level_type <=", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeLike(String value) {
            addCriterion("super_level_type like", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeNotLike(String value) {
            addCriterion("super_level_type not like", value, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeIn(List<String> values) {
            addCriterion("super_level_type in", values, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeNotIn(List<String> values) {
            addCriterion("super_level_type not in", values, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeBetween(String value1, String value2) {
            addCriterion("super_level_type between", value1, value2, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelTypeNotBetween(String value1, String value2) {
            addCriterion("super_level_type not between", value1, value2, "superLevelType");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdIsNull() {
            addCriterion("super_level_price_id is null");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdIsNotNull() {
            addCriterion("super_level_price_id is not null");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdEqualTo(Long value) {
            addCriterion("super_level_price_id =", value, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdNotEqualTo(Long value) {
            addCriterion("super_level_price_id <>", value, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdGreaterThan(Long value) {
            addCriterion("super_level_price_id >", value, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdGreaterThanOrEqualTo(Long value) {
            addCriterion("super_level_price_id >=", value, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdLessThan(Long value) {
            addCriterion("super_level_price_id <", value, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdLessThanOrEqualTo(Long value) {
            addCriterion("super_level_price_id <=", value, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdIn(List<Long> values) {
            addCriterion("super_level_price_id in", values, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdNotIn(List<Long> values) {
            addCriterion("super_level_price_id not in", values, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdBetween(Long value1, Long value2) {
            addCriterion("super_level_price_id between", value1, value2, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperLevelPriceIdNotBetween(Long value1, Long value2) {
            addCriterion("super_level_price_id not between", value1, value2, "superLevelPriceId");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeIsNull() {
            addCriterion("super_card_type is null");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeIsNotNull() {
            addCriterion("super_card_type is not null");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeEqualTo(String value) {
            addCriterion("super_card_type =", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeNotEqualTo(String value) {
            addCriterion("super_card_type <>", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeGreaterThan(String value) {
            addCriterion("super_card_type >", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeGreaterThanOrEqualTo(String value) {
            addCriterion("super_card_type >=", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeLessThan(String value) {
            addCriterion("super_card_type <", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeLessThanOrEqualTo(String value) {
            addCriterion("super_card_type <=", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeLike(String value) {
            addCriterion("super_card_type like", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeNotLike(String value) {
            addCriterion("super_card_type not like", value, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeIn(List<String> values) {
            addCriterion("super_card_type in", values, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeNotIn(List<String> values) {
            addCriterion("super_card_type not in", values, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeBetween(String value1, String value2) {
            addCriterion("super_card_type between", value1, value2, "superCardType");
            return (Criteria) this;
        }

        public Criteria andSuperCardTypeNotBetween(String value1, String value2) {
            addCriterion("super_card_type not between", value1, value2, "superCardType");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(BigDecimal value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(BigDecimal value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(BigDecimal value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(BigDecimal value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<BigDecimal> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<BigDecimal> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andFactAmountIsNull() {
            addCriterion("fact_amount is null");
            return (Criteria) this;
        }

        public Criteria andFactAmountIsNotNull() {
            addCriterion("fact_amount is not null");
            return (Criteria) this;
        }

        public Criteria andFactAmountEqualTo(BigDecimal value) {
            addCriterion("fact_amount =", value, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountNotEqualTo(BigDecimal value) {
            addCriterion("fact_amount <>", value, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountGreaterThan(BigDecimal value) {
            addCriterion("fact_amount >", value, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fact_amount >=", value, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountLessThan(BigDecimal value) {
            addCriterion("fact_amount <", value, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fact_amount <=", value, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountIn(List<BigDecimal> values) {
            addCriterion("fact_amount in", values, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountNotIn(List<BigDecimal> values) {
            addCriterion("fact_amount not in", values, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fact_amount between", value1, value2, "factAmount");
            return (Criteria) this;
        }

        public Criteria andFactAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fact_amount not between", value1, value2, "factAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountIsNull() {
            addCriterion("give_amount is null");
            return (Criteria) this;
        }

        public Criteria andGiveAmountIsNotNull() {
            addCriterion("give_amount is not null");
            return (Criteria) this;
        }

        public Criteria andGiveAmountEqualTo(BigDecimal value) {
            addCriterion("give_amount =", value, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountNotEqualTo(BigDecimal value) {
            addCriterion("give_amount <>", value, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountGreaterThan(BigDecimal value) {
            addCriterion("give_amount >", value, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("give_amount >=", value, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountLessThan(BigDecimal value) {
            addCriterion("give_amount <", value, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("give_amount <=", value, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountIn(List<BigDecimal> values) {
            addCriterion("give_amount in", values, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountNotIn(List<BigDecimal> values) {
            addCriterion("give_amount not in", values, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("give_amount between", value1, value2, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andGiveAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("give_amount not between", value1, value2, "giveAmount");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("finish_time is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("finish_time is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(Date value) {
            addCriterion("finish_time =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(Date value) {
            addCriterion("finish_time <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(Date value) {
            addCriterion("finish_time >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("finish_time >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(Date value) {
            addCriterion("finish_time <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(Date value) {
            addCriterion("finish_time <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<Date> values) {
            addCriterion("finish_time in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<Date> values) {
            addCriterion("finish_time not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(Date value1, Date value2) {
            addCriterion("finish_time between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(Date value1, Date value2) {
            addCriterion("finish_time not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNull() {
            addCriterion("created_by is null");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNotNull() {
            addCriterion("created_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedByEqualTo(String value) {
            addCriterion("created_by =", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotEqualTo(String value) {
            addCriterion("created_by <>", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThan(String value) {
            addCriterion("created_by >", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThanOrEqualTo(String value) {
            addCriterion("created_by >=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThan(String value) {
            addCriterion("created_by <", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThanOrEqualTo(String value) {
            addCriterion("created_by <=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLike(String value) {
            addCriterion("created_by like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotLike(String value) {
            addCriterion("created_by not like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByIn(List<String> values) {
            addCriterion("created_by in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotIn(List<String> values) {
            addCriterion("created_by not in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByBetween(String value1, String value2) {
            addCriterion("created_by between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotBetween(String value1, String value2) {
            addCriterion("created_by not between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNull() {
            addCriterion("created_time is null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNotNull() {
            addCriterion("created_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeEqualTo(Date value) {
            addCriterion("created_time =", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotEqualTo(Date value) {
            addCriterion("created_time <>", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThan(Date value) {
            addCriterion("created_time >", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("created_time >=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThan(Date value) {
            addCriterion("created_time <", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("created_time <=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIn(List<Date> values) {
            addCriterion("created_time in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotIn(List<Date> values) {
            addCriterion("created_time not in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeBetween(Date value1, Date value2) {
            addCriterion("created_time between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("created_time not between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIsNull() {
            addCriterion("last_updated_by is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIsNotNull() {
            addCriterion("last_updated_by is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByEqualTo(String value) {
            addCriterion("last_updated_by =", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotEqualTo(String value) {
            addCriterion("last_updated_by <>", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByGreaterThan(String value) {
            addCriterion("last_updated_by >", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByGreaterThanOrEqualTo(String value) {
            addCriterion("last_updated_by >=", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLessThan(String value) {
            addCriterion("last_updated_by <", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLessThanOrEqualTo(String value) {
            addCriterion("last_updated_by <=", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLike(String value) {
            addCriterion("last_updated_by like", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotLike(String value) {
            addCriterion("last_updated_by not like", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIn(List<String> values) {
            addCriterion("last_updated_by in", values, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotIn(List<String> values) {
            addCriterion("last_updated_by not in", values, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByBetween(String value1, String value2) {
            addCriterion("last_updated_by between", value1, value2, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotBetween(String value1, String value2) {
            addCriterion("last_updated_by not between", value1, value2, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIsNull() {
            addCriterion("last_updated_time is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIsNotNull() {
            addCriterion("last_updated_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeEqualTo(Date value) {
            addCriterion("last_updated_time =", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotEqualTo(Date value) {
            addCriterion("last_updated_time <>", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeGreaterThan(Date value) {
            addCriterion("last_updated_time >", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_updated_time >=", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeLessThan(Date value) {
            addCriterion("last_updated_time <", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_updated_time <=", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIn(List<Date> values) {
            addCriterion("last_updated_time in", values, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotIn(List<Date> values) {
            addCriterion("last_updated_time not in", values, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeBetween(Date value1, Date value2) {
            addCriterion("last_updated_time between", value1, value2, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_updated_time not between", value1, value2, "lastUpdatedTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}